How to: Export data from table/query as a new Word mail merge data source file.
Solution:
Use the 'Save As/Export...' command in the 'File' menu, specify the 'Microsoft Word Merge (*.txt)' file type and a name and location for the exported file, and click 'Export'.
1) Open the desired database.
2) If the Database window is not active, activate the Database window.
3) In the Database window, click the 'Tables' or the 'Queries' tab.
4) Select the table or query to export as a Word mail merge data source file. (The table or query is highlighted.)
5) Select the 'File' menu and select 'Save As/Export...'. (The Save As... dialog box appears.)
6) Select the 'To an external File or Database' radio button.
the To an external File or Database radio button
7) Click 'OK'. (The Save Table/Query <table/query name> in... dialog box appears, where <table/query name> is the name of the selected table or query.)
8) Select 'Microsoft Word Merge (*.txt)' from the 'Save as type' drop-down list.
Selecting Microsoft Word Merge (*.txt)
9) Select the drive where the Word mail merge data source file is to be stored from the 'Save in' drop-down list.
10) Select the specific folder to store the file.
NOTE: If the file is to be stored in a subfolder, continue selecting folders until the desired folder is displayed in the 'Save in' drop-down list box.
11) Do one of the following:
a) Type a name for the exported file in the 'File name' drop-down list box.
b) Accept the name suggested by Access.
12) Click 'Export'. (Access creates a Word mail merge data source file with field names and all the data from the selected table or query.)
Exporting a Word Mail Merge data source file
